package com.zhongwang.business.gen.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class QuotationMainExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public QuotationMainExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andQuoteIdIsNull() {
            addCriterion("quote_id is null");
            return (Criteria) this;
        }

        public Criteria andQuoteIdIsNotNull() {
            addCriterion("quote_id is not null");
            return (Criteria) this;
        }

        public Criteria andQuoteIdEqualTo(Integer value) {
            addCriterion("quote_id =", value, "quoteId");
            return (Criteria) this;
        }

        public Criteria andQuoteIdNotEqualTo(Integer value) {
            addCriterion("quote_id <>", value, "quoteId");
            return (Criteria) this;
        }

        public Criteria andQuoteIdGreaterThan(Integer value) {
            addCriterion("quote_id >", value, "quoteId");
            return (Criteria) this;
        }

        public Criteria andQuoteIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("quote_id >=", value, "quoteId");
            return (Criteria) this;
        }

        public Criteria andQuoteIdLessThan(Integer value) {
            addCriterion("quote_id <", value, "quoteId");
            return (Criteria) this;
        }

        public Criteria andQuoteIdLessThanOrEqualTo(Integer value) {
            addCriterion("quote_id <=", value, "quoteId");
            return (Criteria) this;
        }

        public Criteria andQuoteIdIn(List<Integer> values) {
            addCriterion("quote_id in", values, "quoteId");
            return (Criteria) this;
        }

        public Criteria andQuoteIdNotIn(List<Integer> values) {
            addCriterion("quote_id not in", values, "quoteId");
            return (Criteria) this;
        }

        public Criteria andQuoteIdBetween(Integer value1, Integer value2) {
            addCriterion("quote_id between", value1, value2, "quoteId");
            return (Criteria) this;
        }

        public Criteria andQuoteIdNotBetween(Integer value1, Integer value2) {
            addCriterion("quote_id not between", value1, value2, "quoteId");
            return (Criteria) this;
        }

        public Criteria andQuoteDateIsNull() {
            addCriterion("quote_date is null");
            return (Criteria) this;
        }

        public Criteria andQuoteDateIsNotNull() {
            addCriterion("quote_date is not null");
            return (Criteria) this;
        }

        public Criteria andQuoteDateEqualTo(Date value) {
            addCriterion("quote_date =", value, "quoteDate");
            return (Criteria) this;
        }

        public Criteria andQuoteDateNotEqualTo(Date value) {
            addCriterion("quote_date <>", value, "quoteDate");
            return (Criteria) this;
        }

        public Criteria andQuoteDateGreaterThan(Date value) {
            addCriterion("quote_date >", value, "quoteDate");
            return (Criteria) this;
        }

        public Criteria andQuoteDateGreaterThanOrEqualTo(Date value) {
            addCriterion("quote_date >=", value, "quoteDate");
            return (Criteria) this;
        }

        public Criteria andQuoteDateLessThan(Date value) {
            addCriterion("quote_date <", value, "quoteDate");
            return (Criteria) this;
        }

        public Criteria andQuoteDateLessThanOrEqualTo(Date value) {
            addCriterion("quote_date <=", value, "quoteDate");
            return (Criteria) this;
        }

        public Criteria andQuoteDateIn(List<Date> values) {
            addCriterion("quote_date in", values, "quoteDate");
            return (Criteria) this;
        }

        public Criteria andQuoteDateNotIn(List<Date> values) {
            addCriterion("quote_date not in", values, "quoteDate");
            return (Criteria) this;
        }

        public Criteria andQuoteDateBetween(Date value1, Date value2) {
            addCriterion("quote_date between", value1, value2, "quoteDate");
            return (Criteria) this;
        }

        public Criteria andQuoteDateNotBetween(Date value1, Date value2) {
            addCriterion("quote_date not between", value1, value2, "quoteDate");
            return (Criteria) this;
        }

        public Criteria andQuoteNoIsNull() {
            addCriterion("quote_no is null");
            return (Criteria) this;
        }

        public Criteria andQuoteNoIsNotNull() {
            addCriterion("quote_no is not null");
            return (Criteria) this;
        }

        public Criteria andQuoteNoEqualTo(String value) {
            addCriterion("quote_no =", value, "quoteNo");
            return (Criteria) this;
        }

        public Criteria andQuoteNoNotEqualTo(String value) {
            addCriterion("quote_no <>", value, "quoteNo");
            return (Criteria) this;
        }

        public Criteria andQuoteNoGreaterThan(String value) {
            addCriterion("quote_no >", value, "quoteNo");
            return (Criteria) this;
        }

        public Criteria andQuoteNoGreaterThanOrEqualTo(String value) {
            addCriterion("quote_no >=", value, "quoteNo");
            return (Criteria) this;
        }

        public Criteria andQuoteNoLessThan(String value) {
            addCriterion("quote_no <", value, "quoteNo");
            return (Criteria) this;
        }

        public Criteria andQuoteNoLessThanOrEqualTo(String value) {
            addCriterion("quote_no <=", value, "quoteNo");
            return (Criteria) this;
        }

        public Criteria andQuoteNoLike(String value) {
            addCriterion("quote_no like", value, "quoteNo");
            return (Criteria) this;
        }

        public Criteria andQuoteNoNotLike(String value) {
            addCriterion("quote_no not like", value, "quoteNo");
            return (Criteria) this;
        }

        public Criteria andQuoteNoIn(List<String> values) {
            addCriterion("quote_no in", values, "quoteNo");
            return (Criteria) this;
        }

        public Criteria andQuoteNoNotIn(List<String> values) {
            addCriterion("quote_no not in", values, "quoteNo");
            return (Criteria) this;
        }

        public Criteria andQuoteNoBetween(String value1, String value2) {
            addCriterion("quote_no between", value1, value2, "quoteNo");
            return (Criteria) this;
        }

        public Criteria andQuoteNoNotBetween(String value1, String value2) {
            addCriterion("quote_no not between", value1, value2, "quoteNo");
            return (Criteria) this;
        }

        public Criteria andConsumerNameIsNull() {
            addCriterion("consumer_name is null");
            return (Criteria) this;
        }

        public Criteria andConsumerNameIsNotNull() {
            addCriterion("consumer_name is not null");
            return (Criteria) this;
        }

        public Criteria andConsumerNameEqualTo(String value) {
            addCriterion("consumer_name =", value, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameNotEqualTo(String value) {
            addCriterion("consumer_name <>", value, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameGreaterThan(String value) {
            addCriterion("consumer_name >", value, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameGreaterThanOrEqualTo(String value) {
            addCriterion("consumer_name >=", value, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameLessThan(String value) {
            addCriterion("consumer_name <", value, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameLessThanOrEqualTo(String value) {
            addCriterion("consumer_name <=", value, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameLike(String value) {
            addCriterion("consumer_name like", value, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameNotLike(String value) {
            addCriterion("consumer_name not like", value, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameIn(List<String> values) {
            addCriterion("consumer_name in", values, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameNotIn(List<String> values) {
            addCriterion("consumer_name not in", values, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameBetween(String value1, String value2) {
            addCriterion("consumer_name between", value1, value2, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameNotBetween(String value1, String value2) {
            addCriterion("consumer_name not between", value1, value2, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerAttnIsNull() {
            addCriterion("consumer_attn is null");
            return (Criteria) this;
        }

        public Criteria andConsumerAttnIsNotNull() {
            addCriterion("consumer_attn is not null");
            return (Criteria) this;
        }

        public Criteria andConsumerAttnEqualTo(String value) {
            addCriterion("consumer_attn =", value, "consumerAttn");
            return (Criteria) this;
        }

        public Criteria andConsumerAttnNotEqualTo(String value) {
            addCriterion("consumer_attn <>", value, "consumerAttn");
            return (Criteria) this;
        }

        public Criteria andConsumerAttnGreaterThan(String value) {
            addCriterion("consumer_attn >", value, "consumerAttn");
            return (Criteria) this;
        }

        public Criteria andConsumerAttnGreaterThanOrEqualTo(String value) {
            addCriterion("consumer_attn >=", value, "consumerAttn");
            return (Criteria) this;
        }

        public Criteria andConsumerAttnLessThan(String value) {
            addCriterion("consumer_attn <", value, "consumerAttn");
            return (Criteria) this;
        }

        public Criteria andConsumerAttnLessThanOrEqualTo(String value) {
            addCriterion("consumer_attn <=", value, "consumerAttn");
            return (Criteria) this;
        }

        public Criteria andConsumerAttnLike(String value) {
            addCriterion("consumer_attn like", value, "consumerAttn");
            return (Criteria) this;
        }

        public Criteria andConsumerAttnNotLike(String value) {
            addCriterion("consumer_attn not like", value, "consumerAttn");
            return (Criteria) this;
        }

        public Criteria andConsumerAttnIn(List<String> values) {
            addCriterion("consumer_attn in", values, "consumerAttn");
            return (Criteria) this;
        }

        public Criteria andConsumerAttnNotIn(List<String> values) {
            addCriterion("consumer_attn not in", values, "consumerAttn");
            return (Criteria) this;
        }

        public Criteria andConsumerAttnBetween(String value1, String value2) {
            addCriterion("consumer_attn between", value1, value2, "consumerAttn");
            return (Criteria) this;
        }

        public Criteria andConsumerAttnNotBetween(String value1, String value2) {
            addCriterion("consumer_attn not between", value1, value2, "consumerAttn");
            return (Criteria) this;
        }

        public Criteria andConsumerTelIsNull() {
            addCriterion("consumer_tel is null");
            return (Criteria) this;
        }

        public Criteria andConsumerTelIsNotNull() {
            addCriterion("consumer_tel is not null");
            return (Criteria) this;
        }

        public Criteria andConsumerTelEqualTo(String value) {
            addCriterion("consumer_tel =", value, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelNotEqualTo(String value) {
            addCriterion("consumer_tel <>", value, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelGreaterThan(String value) {
            addCriterion("consumer_tel >", value, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelGreaterThanOrEqualTo(String value) {
            addCriterion("consumer_tel >=", value, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelLessThan(String value) {
            addCriterion("consumer_tel <", value, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelLessThanOrEqualTo(String value) {
            addCriterion("consumer_tel <=", value, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelLike(String value) {
            addCriterion("consumer_tel like", value, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelNotLike(String value) {
            addCriterion("consumer_tel not like", value, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelIn(List<String> values) {
            addCriterion("consumer_tel in", values, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelNotIn(List<String> values) {
            addCriterion("consumer_tel not in", values, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelBetween(String value1, String value2) {
            addCriterion("consumer_tel between", value1, value2, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelNotBetween(String value1, String value2) {
            addCriterion("consumer_tel not between", value1, value2, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailIsNull() {
            addCriterion("consumer_email is null");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailIsNotNull() {
            addCriterion("consumer_email is not null");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailEqualTo(String value) {
            addCriterion("consumer_email =", value, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailNotEqualTo(String value) {
            addCriterion("consumer_email <>", value, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailGreaterThan(String value) {
            addCriterion("consumer_email >", value, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailGreaterThanOrEqualTo(String value) {
            addCriterion("consumer_email >=", value, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailLessThan(String value) {
            addCriterion("consumer_email <", value, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailLessThanOrEqualTo(String value) {
            addCriterion("consumer_email <=", value, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailLike(String value) {
            addCriterion("consumer_email like", value, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailNotLike(String value) {
            addCriterion("consumer_email not like", value, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailIn(List<String> values) {
            addCriterion("consumer_email in", values, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailNotIn(List<String> values) {
            addCriterion("consumer_email not in", values, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailBetween(String value1, String value2) {
            addCriterion("consumer_email between", value1, value2, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailNotBetween(String value1, String value2) {
            addCriterion("consumer_email not between", value1, value2, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andSupplierNameIsNull() {
            addCriterion("supplier_name is null");
            return (Criteria) this;
        }

        public Criteria andSupplierNameIsNotNull() {
            addCriterion("supplier_name is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierNameEqualTo(String value) {
            addCriterion("supplier_name =", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameNotEqualTo(String value) {
            addCriterion("supplier_name <>", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameGreaterThan(String value) {
            addCriterion("supplier_name >", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameGreaterThanOrEqualTo(String value) {
            addCriterion("supplier_name >=", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameLessThan(String value) {
            addCriterion("supplier_name <", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameLessThanOrEqualTo(String value) {
            addCriterion("supplier_name <=", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameLike(String value) {
            addCriterion("supplier_name like", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameNotLike(String value) {
            addCriterion("supplier_name not like", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameIn(List<String> values) {
            addCriterion("supplier_name in", values, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameNotIn(List<String> values) {
            addCriterion("supplier_name not in", values, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameBetween(String value1, String value2) {
            addCriterion("supplier_name between", value1, value2, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameNotBetween(String value1, String value2) {
            addCriterion("supplier_name not between", value1, value2, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierAttnIsNull() {
            addCriterion("supplier_attn is null");
            return (Criteria) this;
        }

        public Criteria andSupplierAttnIsNotNull() {
            addCriterion("supplier_attn is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierAttnEqualTo(String value) {
            addCriterion("supplier_attn =", value, "supplierAttn");
            return (Criteria) this;
        }

        public Criteria andSupplierAttnNotEqualTo(String value) {
            addCriterion("supplier_attn <>", value, "supplierAttn");
            return (Criteria) this;
        }

        public Criteria andSupplierAttnGreaterThan(String value) {
            addCriterion("supplier_attn >", value, "supplierAttn");
            return (Criteria) this;
        }

        public Criteria andSupplierAttnGreaterThanOrEqualTo(String value) {
            addCriterion("supplier_attn >=", value, "supplierAttn");
            return (Criteria) this;
        }

        public Criteria andSupplierAttnLessThan(String value) {
            addCriterion("supplier_attn <", value, "supplierAttn");
            return (Criteria) this;
        }

        public Criteria andSupplierAttnLessThanOrEqualTo(String value) {
            addCriterion("supplier_attn <=", value, "supplierAttn");
            return (Criteria) this;
        }

        public Criteria andSupplierAttnLike(String value) {
            addCriterion("supplier_attn like", value, "supplierAttn");
            return (Criteria) this;
        }

        public Criteria andSupplierAttnNotLike(String value) {
            addCriterion("supplier_attn not like", value, "supplierAttn");
            return (Criteria) this;
        }

        public Criteria andSupplierAttnIn(List<String> values) {
            addCriterion("supplier_attn in", values, "supplierAttn");
            return (Criteria) this;
        }

        public Criteria andSupplierAttnNotIn(List<String> values) {
            addCriterion("supplier_attn not in", values, "supplierAttn");
            return (Criteria) this;
        }

        public Criteria andSupplierAttnBetween(String value1, String value2) {
            addCriterion("supplier_attn between", value1, value2, "supplierAttn");
            return (Criteria) this;
        }

        public Criteria andSupplierAttnNotBetween(String value1, String value2) {
            addCriterion("supplier_attn not between", value1, value2, "supplierAttn");
            return (Criteria) this;
        }

        public Criteria andSupplierTelIsNull() {
            addCriterion("supplier_tel is null");
            return (Criteria) this;
        }

        public Criteria andSupplierTelIsNotNull() {
            addCriterion("supplier_tel is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierTelEqualTo(String value) {
            addCriterion("supplier_tel =", value, "supplierTel");
            return (Criteria) this;
        }

        public Criteria andSupplierTelNotEqualTo(String value) {
            addCriterion("supplier_tel <>", value, "supplierTel");
            return (Criteria) this;
        }

        public Criteria andSupplierTelGreaterThan(String value) {
            addCriterion("supplier_tel >", value, "supplierTel");
            return (Criteria) this;
        }

        public Criteria andSupplierTelGreaterThanOrEqualTo(String value) {
            addCriterion("supplier_tel >=", value, "supplierTel");
            return (Criteria) this;
        }

        public Criteria andSupplierTelLessThan(String value) {
            addCriterion("supplier_tel <", value, "supplierTel");
            return (Criteria) this;
        }

        public Criteria andSupplierTelLessThanOrEqualTo(String value) {
            addCriterion("supplier_tel <=", value, "supplierTel");
            return (Criteria) this;
        }

        public Criteria andSupplierTelLike(String value) {
            addCriterion("supplier_tel like", value, "supplierTel");
            return (Criteria) this;
        }

        public Criteria andSupplierTelNotLike(String value) {
            addCriterion("supplier_tel not like", value, "supplierTel");
            return (Criteria) this;
        }

        public Criteria andSupplierTelIn(List<String> values) {
            addCriterion("supplier_tel in", values, "supplierTel");
            return (Criteria) this;
        }

        public Criteria andSupplierTelNotIn(List<String> values) {
            addCriterion("supplier_tel not in", values, "supplierTel");
            return (Criteria) this;
        }

        public Criteria andSupplierTelBetween(String value1, String value2) {
            addCriterion("supplier_tel between", value1, value2, "supplierTel");
            return (Criteria) this;
        }

        public Criteria andSupplierTelNotBetween(String value1, String value2) {
            addCriterion("supplier_tel not between", value1, value2, "supplierTel");
            return (Criteria) this;
        }

        public Criteria andSupplierEmailIsNull() {
            addCriterion("supplier_email is null");
            return (Criteria) this;
        }

        public Criteria andSupplierEmailIsNotNull() {
            addCriterion("supplier_email is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierEmailEqualTo(String value) {
            addCriterion("supplier_email =", value, "supplierEmail");
            return (Criteria) this;
        }

        public Criteria andSupplierEmailNotEqualTo(String value) {
            addCriterion("supplier_email <>", value, "supplierEmail");
            return (Criteria) this;
        }

        public Criteria andSupplierEmailGreaterThan(String value) {
            addCriterion("supplier_email >", value, "supplierEmail");
            return (Criteria) this;
        }

        public Criteria andSupplierEmailGreaterThanOrEqualTo(String value) {
            addCriterion("supplier_email >=", value, "supplierEmail");
            return (Criteria) this;
        }

        public Criteria andSupplierEmailLessThan(String value) {
            addCriterion("supplier_email <", value, "supplierEmail");
            return (Criteria) this;
        }

        public Criteria andSupplierEmailLessThanOrEqualTo(String value) {
            addCriterion("supplier_email <=", value, "supplierEmail");
            return (Criteria) this;
        }

        public Criteria andSupplierEmailLike(String value) {
            addCriterion("supplier_email like", value, "supplierEmail");
            return (Criteria) this;
        }

        public Criteria andSupplierEmailNotLike(String value) {
            addCriterion("supplier_email not like", value, "supplierEmail");
            return (Criteria) this;
        }

        public Criteria andSupplierEmailIn(List<String> values) {
            addCriterion("supplier_email in", values, "supplierEmail");
            return (Criteria) this;
        }

        public Criteria andSupplierEmailNotIn(List<String> values) {
            addCriterion("supplier_email not in", values, "supplierEmail");
            return (Criteria) this;
        }

        public Criteria andSupplierEmailBetween(String value1, String value2) {
            addCriterion("supplier_email between", value1, value2, "supplierEmail");
            return (Criteria) this;
        }

        public Criteria andSupplierEmailNotBetween(String value1, String value2) {
            addCriterion("supplier_email not between", value1, value2, "supplierEmail");
            return (Criteria) this;
        }

        public Criteria andQuoteGentDateIsNull() {
            addCriterion("quote_gent_date is null");
            return (Criteria) this;
        }

        public Criteria andQuoteGentDateIsNotNull() {
            addCriterion("quote_gent_date is not null");
            return (Criteria) this;
        }

        public Criteria andQuoteGentDateEqualTo(Date value) {
            addCriterion("quote_gent_date =", value, "quoteGentDate");
            return (Criteria) this;
        }

        public Criteria andQuoteGentDateNotEqualTo(Date value) {
            addCriterion("quote_gent_date <>", value, "quoteGentDate");
            return (Criteria) this;
        }

        public Criteria andQuoteGentDateGreaterThan(Date value) {
            addCriterion("quote_gent_date >", value, "quoteGentDate");
            return (Criteria) this;
        }

        public Criteria andQuoteGentDateGreaterThanOrEqualTo(Date value) {
            addCriterion("quote_gent_date >=", value, "quoteGentDate");
            return (Criteria) this;
        }

        public Criteria andQuoteGentDateLessThan(Date value) {
            addCriterion("quote_gent_date <", value, "quoteGentDate");
            return (Criteria) this;
        }

        public Criteria andQuoteGentDateLessThanOrEqualTo(Date value) {
            addCriterion("quote_gent_date <=", value, "quoteGentDate");
            return (Criteria) this;
        }

        public Criteria andQuoteGentDateIn(List<Date> values) {
            addCriterion("quote_gent_date in", values, "quoteGentDate");
            return (Criteria) this;
        }

        public Criteria andQuoteGentDateNotIn(List<Date> values) {
            addCriterion("quote_gent_date not in", values, "quoteGentDate");
            return (Criteria) this;
        }

        public Criteria andQuoteGentDateBetween(Date value1, Date value2) {
            addCriterion("quote_gent_date between", value1, value2, "quoteGentDate");
            return (Criteria) this;
        }

        public Criteria andQuoteGentDateNotBetween(Date value1, Date value2) {
            addCriterion("quote_gent_date not between", value1, value2, "quoteGentDate");
            return (Criteria) this;
        }

        public Criteria andQuoteStatusIsNull() {
            addCriterion("quote_status is null");
            return (Criteria) this;
        }

        public Criteria andQuoteStatusIsNotNull() {
            addCriterion("quote_status is not null");
            return (Criteria) this;
        }

        public Criteria andQuoteStatusEqualTo(Integer value) {
            addCriterion("quote_status =", value, "quoteStatus");
            return (Criteria) this;
        }

        public Criteria andQuoteStatusNotEqualTo(Integer value) {
            addCriterion("quote_status <>", value, "quoteStatus");
            return (Criteria) this;
        }

        public Criteria andQuoteStatusGreaterThan(Integer value) {
            addCriterion("quote_status >", value, "quoteStatus");
            return (Criteria) this;
        }

        public Criteria andQuoteStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("quote_status >=", value, "quoteStatus");
            return (Criteria) this;
        }

        public Criteria andQuoteStatusLessThan(Integer value) {
            addCriterion("quote_status <", value, "quoteStatus");
            return (Criteria) this;
        }

        public Criteria andQuoteStatusLessThanOrEqualTo(Integer value) {
            addCriterion("quote_status <=", value, "quoteStatus");
            return (Criteria) this;
        }

        public Criteria andQuoteStatusIn(List<Integer> values) {
            addCriterion("quote_status in", values, "quoteStatus");
            return (Criteria) this;
        }

        public Criteria andQuoteStatusNotIn(List<Integer> values) {
            addCriterion("quote_status not in", values, "quoteStatus");
            return (Criteria) this;
        }

        public Criteria andQuoteStatusBetween(Integer value1, Integer value2) {
            addCriterion("quote_status between", value1, value2, "quoteStatus");
            return (Criteria) this;
        }

        public Criteria andQuoteStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("quote_status not between", value1, value2, "quoteStatus");
            return (Criteria) this;
        }

        public Criteria andTotalAmountIncludedTaxIsNull() {
            addCriterion("total_amount_included_tax is null");
            return (Criteria) this;
        }

        public Criteria andTotalAmountIncludedTaxIsNotNull() {
            addCriterion("total_amount_included_tax is not null");
            return (Criteria) this;
        }

        public Criteria andTotalAmountIncludedTaxEqualTo(BigDecimal value) {
            addCriterion("total_amount_included_tax =", value, "totalAmountIncludedTax");
            return (Criteria) this;
        }

        public Criteria andTotalAmountIncludedTaxNotEqualTo(BigDecimal value) {
            addCriterion("total_amount_included_tax <>", value, "totalAmountIncludedTax");
            return (Criteria) this;
        }

        public Criteria andTotalAmountIncludedTaxGreaterThan(BigDecimal value) {
            addCriterion("total_amount_included_tax >", value, "totalAmountIncludedTax");
            return (Criteria) this;
        }

        public Criteria andTotalAmountIncludedTaxGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("total_amount_included_tax >=", value, "totalAmountIncludedTax");
            return (Criteria) this;
        }

        public Criteria andTotalAmountIncludedTaxLessThan(BigDecimal value) {
            addCriterion("total_amount_included_tax <", value, "totalAmountIncludedTax");
            return (Criteria) this;
        }

        public Criteria andTotalAmountIncludedTaxLessThanOrEqualTo(BigDecimal value) {
            addCriterion("total_amount_included_tax <=", value, "totalAmountIncludedTax");
            return (Criteria) this;
        }

        public Criteria andTotalAmountIncludedTaxIn(List<BigDecimal> values) {
            addCriterion("total_amount_included_tax in", values, "totalAmountIncludedTax");
            return (Criteria) this;
        }

        public Criteria andTotalAmountIncludedTaxNotIn(List<BigDecimal> values) {
            addCriterion("total_amount_included_tax not in", values, "totalAmountIncludedTax");
            return (Criteria) this;
        }

        public Criteria andTotalAmountIncludedTaxBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_amount_included_tax between", value1, value2, "totalAmountIncludedTax");
            return (Criteria) this;
        }

        public Criteria andTotalAmountIncludedTaxNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_amount_included_tax not between", value1, value2, "totalAmountIncludedTax");
            return (Criteria) this;
        }

        public Criteria andQuoteAvaStatusIsNull() {
            addCriterion("quote_ava_status is null");
            return (Criteria) this;
        }

        public Criteria andQuoteAvaStatusIsNotNull() {
            addCriterion("quote_ava_status is not null");
            return (Criteria) this;
        }

        public Criteria andQuoteAvaStatusEqualTo(Integer value) {
            addCriterion("quote_ava_status =", value, "quoteAvaStatus");
            return (Criteria) this;
        }

        public Criteria andQuoteAvaStatusNotEqualTo(Integer value) {
            addCriterion("quote_ava_status <>", value, "quoteAvaStatus");
            return (Criteria) this;
        }

        public Criteria andQuoteAvaStatusGreaterThan(Integer value) {
            addCriterion("quote_ava_status >", value, "quoteAvaStatus");
            return (Criteria) this;
        }

        public Criteria andQuoteAvaStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("quote_ava_status >=", value, "quoteAvaStatus");
            return (Criteria) this;
        }

        public Criteria andQuoteAvaStatusLessThan(Integer value) {
            addCriterion("quote_ava_status <", value, "quoteAvaStatus");
            return (Criteria) this;
        }

        public Criteria andQuoteAvaStatusLessThanOrEqualTo(Integer value) {
            addCriterion("quote_ava_status <=", value, "quoteAvaStatus");
            return (Criteria) this;
        }

        public Criteria andQuoteAvaStatusIn(List<Integer> values) {
            addCriterion("quote_ava_status in", values, "quoteAvaStatus");
            return (Criteria) this;
        }

        public Criteria andQuoteAvaStatusNotIn(List<Integer> values) {
            addCriterion("quote_ava_status not in", values, "quoteAvaStatus");
            return (Criteria) this;
        }

        public Criteria andQuoteAvaStatusBetween(Integer value1, Integer value2) {
            addCriterion("quote_ava_status between", value1, value2, "quoteAvaStatus");
            return (Criteria) this;
        }

        public Criteria andQuoteAvaStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("quote_ava_status not between", value1, value2, "quoteAvaStatus");
            return (Criteria) this;
        }

        public Criteria andCreateNameIsNull() {
            addCriterion("create_name is null");
            return (Criteria) this;
        }

        public Criteria andCreateNameIsNotNull() {
            addCriterion("create_name is not null");
            return (Criteria) this;
        }

        public Criteria andCreateNameEqualTo(String value) {
            addCriterion("create_name =", value, "createName");
            return (Criteria) this;
        }

        public Criteria andCreateNameNotEqualTo(String value) {
            addCriterion("create_name <>", value, "createName");
            return (Criteria) this;
        }

        public Criteria andCreateNameGreaterThan(String value) {
            addCriterion("create_name >", value, "createName");
            return (Criteria) this;
        }

        public Criteria andCreateNameGreaterThanOrEqualTo(String value) {
            addCriterion("create_name >=", value, "createName");
            return (Criteria) this;
        }

        public Criteria andCreateNameLessThan(String value) {
            addCriterion("create_name <", value, "createName");
            return (Criteria) this;
        }

        public Criteria andCreateNameLessThanOrEqualTo(String value) {
            addCriterion("create_name <=", value, "createName");
            return (Criteria) this;
        }

        public Criteria andCreateNameLike(String value) {
            addCriterion("create_name like", value, "createName");
            return (Criteria) this;
        }

        public Criteria andCreateNameNotLike(String value) {
            addCriterion("create_name not like", value, "createName");
            return (Criteria) this;
        }

        public Criteria andCreateNameIn(List<String> values) {
            addCriterion("create_name in", values, "createName");
            return (Criteria) this;
        }

        public Criteria andCreateNameNotIn(List<String> values) {
            addCriterion("create_name not in", values, "createName");
            return (Criteria) this;
        }

        public Criteria andCreateNameBetween(String value1, String value2) {
            addCriterion("create_name between", value1, value2, "createName");
            return (Criteria) this;
        }

        public Criteria andCreateNameNotBetween(String value1, String value2) {
            addCriterion("create_name not between", value1, value2, "createName");
            return (Criteria) this;
        }

        public Criteria andDesignIsNull() {
            addCriterion("design is null");
            return (Criteria) this;
        }

        public Criteria andDesignIsNotNull() {
            addCriterion("design is not null");
            return (Criteria) this;
        }

        public Criteria andDesignEqualTo(Integer value) {
            addCriterion("design =", value, "design");
            return (Criteria) this;
        }

        public Criteria andDesignNotEqualTo(Integer value) {
            addCriterion("design <>", value, "design");
            return (Criteria) this;
        }

        public Criteria andDesignGreaterThan(Integer value) {
            addCriterion("design >", value, "design");
            return (Criteria) this;
        }

        public Criteria andDesignGreaterThanOrEqualTo(Integer value) {
            addCriterion("design >=", value, "design");
            return (Criteria) this;
        }

        public Criteria andDesignLessThan(Integer value) {
            addCriterion("design <", value, "design");
            return (Criteria) this;
        }

        public Criteria andDesignLessThanOrEqualTo(Integer value) {
            addCriterion("design <=", value, "design");
            return (Criteria) this;
        }

        public Criteria andDesignIn(List<Integer> values) {
            addCriterion("design in", values, "design");
            return (Criteria) this;
        }

        public Criteria andDesignNotIn(List<Integer> values) {
            addCriterion("design not in", values, "design");
            return (Criteria) this;
        }

        public Criteria andDesignBetween(Integer value1, Integer value2) {
            addCriterion("design between", value1, value2, "design");
            return (Criteria) this;
        }

        public Criteria andDesignNotBetween(Integer value1, Integer value2) {
            addCriterion("design not between", value1, value2, "design");
            return (Criteria) this;
        }

        public Criteria andExcludeItemIsNull() {
            addCriterion("exclude_item is null");
            return (Criteria) this;
        }

        public Criteria andExcludeItemIsNotNull() {
            addCriterion("exclude_item is not null");
            return (Criteria) this;
        }

        public Criteria andExcludeItemEqualTo(String value) {
            addCriterion("exclude_item =", value, "excludeItem");
            return (Criteria) this;
        }

        public Criteria andExcludeItemNotEqualTo(String value) {
            addCriterion("exclude_item <>", value, "excludeItem");
            return (Criteria) this;
        }

        public Criteria andExcludeItemGreaterThan(String value) {
            addCriterion("exclude_item >", value, "excludeItem");
            return (Criteria) this;
        }

        public Criteria andExcludeItemGreaterThanOrEqualTo(String value) {
            addCriterion("exclude_item >=", value, "excludeItem");
            return (Criteria) this;
        }

        public Criteria andExcludeItemLessThan(String value) {
            addCriterion("exclude_item <", value, "excludeItem");
            return (Criteria) this;
        }

        public Criteria andExcludeItemLessThanOrEqualTo(String value) {
            addCriterion("exclude_item <=", value, "excludeItem");
            return (Criteria) this;
        }

        public Criteria andExcludeItemLike(String value) {
            addCriterion("exclude_item like", value, "excludeItem");
            return (Criteria) this;
        }

        public Criteria andExcludeItemNotLike(String value) {
            addCriterion("exclude_item not like", value, "excludeItem");
            return (Criteria) this;
        }

        public Criteria andExcludeItemIn(List<String> values) {
            addCriterion("exclude_item in", values, "excludeItem");
            return (Criteria) this;
        }

        public Criteria andExcludeItemNotIn(List<String> values) {
            addCriterion("exclude_item not in", values, "excludeItem");
            return (Criteria) this;
        }

        public Criteria andExcludeItemBetween(String value1, String value2) {
            addCriterion("exclude_item between", value1, value2, "excludeItem");
            return (Criteria) this;
        }

        public Criteria andExcludeItemNotBetween(String value1, String value2) {
            addCriterion("exclude_item not between", value1, value2, "excludeItem");
            return (Criteria) this;
        }

        public Criteria andMaterialIsNull() {
            addCriterion("material is null");
            return (Criteria) this;
        }

        public Criteria andMaterialIsNotNull() {
            addCriterion("material is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialEqualTo(Integer value) {
            addCriterion("material =", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotEqualTo(Integer value) {
            addCriterion("material <>", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialGreaterThan(Integer value) {
            addCriterion("material >", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialGreaterThanOrEqualTo(Integer value) {
            addCriterion("material >=", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialLessThan(Integer value) {
            addCriterion("material <", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialLessThanOrEqualTo(Integer value) {
            addCriterion("material <=", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialIn(List<Integer> values) {
            addCriterion("material in", values, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotIn(List<Integer> values) {
            addCriterion("material not in", values, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialBetween(Integer value1, Integer value2) {
            addCriterion("material between", value1, value2, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotBetween(Integer value1, Integer value2) {
            addCriterion("material not between", value1, value2, "material");
            return (Criteria) this;
        }

        public Criteria andManufatureIsNull() {
            addCriterion("manufature is null");
            return (Criteria) this;
        }

        public Criteria andManufatureIsNotNull() {
            addCriterion("manufature is not null");
            return (Criteria) this;
        }

        public Criteria andManufatureEqualTo(Integer value) {
            addCriterion("manufature =", value, "manufature");
            return (Criteria) this;
        }

        public Criteria andManufatureNotEqualTo(Integer value) {
            addCriterion("manufature <>", value, "manufature");
            return (Criteria) this;
        }

        public Criteria andManufatureGreaterThan(Integer value) {
            addCriterion("manufature >", value, "manufature");
            return (Criteria) this;
        }

        public Criteria andManufatureGreaterThanOrEqualTo(Integer value) {
            addCriterion("manufature >=", value, "manufature");
            return (Criteria) this;
        }

        public Criteria andManufatureLessThan(Integer value) {
            addCriterion("manufature <", value, "manufature");
            return (Criteria) this;
        }

        public Criteria andManufatureLessThanOrEqualTo(Integer value) {
            addCriterion("manufature <=", value, "manufature");
            return (Criteria) this;
        }

        public Criteria andManufatureIn(List<Integer> values) {
            addCriterion("manufature in", values, "manufature");
            return (Criteria) this;
        }

        public Criteria andManufatureNotIn(List<Integer> values) {
            addCriterion("manufature not in", values, "manufature");
            return (Criteria) this;
        }

        public Criteria andManufatureBetween(Integer value1, Integer value2) {
            addCriterion("manufature between", value1, value2, "manufature");
            return (Criteria) this;
        }

        public Criteria andManufatureNotBetween(Integer value1, Integer value2) {
            addCriterion("manufature not between", value1, value2, "manufature");
            return (Criteria) this;
        }

        public Criteria andPackgIsNull() {
            addCriterion("packg is null");
            return (Criteria) this;
        }

        public Criteria andPackgIsNotNull() {
            addCriterion("packg is not null");
            return (Criteria) this;
        }

        public Criteria andPackgEqualTo(Integer value) {
            addCriterion("packg =", value, "packg");
            return (Criteria) this;
        }

        public Criteria andPackgNotEqualTo(Integer value) {
            addCriterion("packg <>", value, "packg");
            return (Criteria) this;
        }

        public Criteria andPackgGreaterThan(Integer value) {
            addCriterion("packg >", value, "packg");
            return (Criteria) this;
        }

        public Criteria andPackgGreaterThanOrEqualTo(Integer value) {
            addCriterion("packg >=", value, "packg");
            return (Criteria) this;
        }

        public Criteria andPackgLessThan(Integer value) {
            addCriterion("packg <", value, "packg");
            return (Criteria) this;
        }

        public Criteria andPackgLessThanOrEqualTo(Integer value) {
            addCriterion("packg <=", value, "packg");
            return (Criteria) this;
        }

        public Criteria andPackgIn(List<Integer> values) {
            addCriterion("packg in", values, "packg");
            return (Criteria) this;
        }

        public Criteria andPackgNotIn(List<Integer> values) {
            addCriterion("packg not in", values, "packg");
            return (Criteria) this;
        }

        public Criteria andPackgBetween(Integer value1, Integer value2) {
            addCriterion("packg between", value1, value2, "packg");
            return (Criteria) this;
        }

        public Criteria andPackgNotBetween(Integer value1, Integer value2) {
            addCriterion("packg not between", value1, value2, "packg");
            return (Criteria) this;
        }

        public Criteria andTransportIsNull() {
            addCriterion("transport is null");
            return (Criteria) this;
        }

        public Criteria andTransportIsNotNull() {
            addCriterion("transport is not null");
            return (Criteria) this;
        }

        public Criteria andTransportEqualTo(Integer value) {
            addCriterion("transport =", value, "transport");
            return (Criteria) this;
        }

        public Criteria andTransportNotEqualTo(Integer value) {
            addCriterion("transport <>", value, "transport");
            return (Criteria) this;
        }

        public Criteria andTransportGreaterThan(Integer value) {
            addCriterion("transport >", value, "transport");
            return (Criteria) this;
        }

        public Criteria andTransportGreaterThanOrEqualTo(Integer value) {
            addCriterion("transport >=", value, "transport");
            return (Criteria) this;
        }

        public Criteria andTransportLessThan(Integer value) {
            addCriterion("transport <", value, "transport");
            return (Criteria) this;
        }

        public Criteria andTransportLessThanOrEqualTo(Integer value) {
            addCriterion("transport <=", value, "transport");
            return (Criteria) this;
        }

        public Criteria andTransportIn(List<Integer> values) {
            addCriterion("transport in", values, "transport");
            return (Criteria) this;
        }

        public Criteria andTransportNotIn(List<Integer> values) {
            addCriterion("transport not in", values, "transport");
            return (Criteria) this;
        }

        public Criteria andTransportBetween(Integer value1, Integer value2) {
            addCriterion("transport between", value1, value2, "transport");
            return (Criteria) this;
        }

        public Criteria andTransportNotBetween(Integer value1, Integer value2) {
            addCriterion("transport not between", value1, value2, "transport");
            return (Criteria) this;
        }

        public Criteria andInstallIsNull() {
            addCriterion("install is null");
            return (Criteria) this;
        }

        public Criteria andInstallIsNotNull() {
            addCriterion("install is not null");
            return (Criteria) this;
        }

        public Criteria andInstallEqualTo(Integer value) {
            addCriterion("install =", value, "install");
            return (Criteria) this;
        }

        public Criteria andInstallNotEqualTo(Integer value) {
            addCriterion("install <>", value, "install");
            return (Criteria) this;
        }

        public Criteria andInstallGreaterThan(Integer value) {
            addCriterion("install >", value, "install");
            return (Criteria) this;
        }

        public Criteria andInstallGreaterThanOrEqualTo(Integer value) {
            addCriterion("install >=", value, "install");
            return (Criteria) this;
        }

        public Criteria andInstallLessThan(Integer value) {
            addCriterion("install <", value, "install");
            return (Criteria) this;
        }

        public Criteria andInstallLessThanOrEqualTo(Integer value) {
            addCriterion("install <=", value, "install");
            return (Criteria) this;
        }

        public Criteria andInstallIn(List<Integer> values) {
            addCriterion("install in", values, "install");
            return (Criteria) this;
        }

        public Criteria andInstallNotIn(List<Integer> values) {
            addCriterion("install not in", values, "install");
            return (Criteria) this;
        }

        public Criteria andInstallBetween(Integer value1, Integer value2) {
            addCriterion("install between", value1, value2, "install");
            return (Criteria) this;
        }

        public Criteria andInstallNotBetween(Integer value1, Integer value2) {
            addCriterion("install not between", value1, value2, "install");
            return (Criteria) this;
        }

        public Criteria andDebugIsNull() {
            addCriterion("debug is null");
            return (Criteria) this;
        }

        public Criteria andDebugIsNotNull() {
            addCriterion("debug is not null");
            return (Criteria) this;
        }

        public Criteria andDebugEqualTo(Integer value) {
            addCriterion("debug =", value, "debug");
            return (Criteria) this;
        }

        public Criteria andDebugNotEqualTo(Integer value) {
            addCriterion("debug <>", value, "debug");
            return (Criteria) this;
        }

        public Criteria andDebugGreaterThan(Integer value) {
            addCriterion("debug >", value, "debug");
            return (Criteria) this;
        }

        public Criteria andDebugGreaterThanOrEqualTo(Integer value) {
            addCriterion("debug >=", value, "debug");
            return (Criteria) this;
        }

        public Criteria andDebugLessThan(Integer value) {
            addCriterion("debug <", value, "debug");
            return (Criteria) this;
        }

        public Criteria andDebugLessThanOrEqualTo(Integer value) {
            addCriterion("debug <=", value, "debug");
            return (Criteria) this;
        }

        public Criteria andDebugIn(List<Integer> values) {
            addCriterion("debug in", values, "debug");
            return (Criteria) this;
        }

        public Criteria andDebugNotIn(List<Integer> values) {
            addCriterion("debug not in", values, "debug");
            return (Criteria) this;
        }

        public Criteria andDebugBetween(Integer value1, Integer value2) {
            addCriterion("debug between", value1, value2, "debug");
            return (Criteria) this;
        }

        public Criteria andDebugNotBetween(Integer value1, Integer value2) {
            addCriterion("debug not between", value1, value2, "debug");
            return (Criteria) this;
        }

        public Criteria andCosTypeIsNull() {
            addCriterion("cos_type is null");
            return (Criteria) this;
        }

        public Criteria andCosTypeIsNotNull() {
            addCriterion("cos_type is not null");
            return (Criteria) this;
        }

        public Criteria andCosTypeEqualTo(Integer value) {
            addCriterion("cos_type =", value, "cosType");
            return (Criteria) this;
        }

        public Criteria andCosTypeNotEqualTo(Integer value) {
            addCriterion("cos_type <>", value, "cosType");
            return (Criteria) this;
        }

        public Criteria andCosTypeGreaterThan(Integer value) {
            addCriterion("cos_type >", value, "cosType");
            return (Criteria) this;
        }

        public Criteria andCosTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("cos_type >=", value, "cosType");
            return (Criteria) this;
        }

        public Criteria andCosTypeLessThan(Integer value) {
            addCriterion("cos_type <", value, "cosType");
            return (Criteria) this;
        }

        public Criteria andCosTypeLessThanOrEqualTo(Integer value) {
            addCriterion("cos_type <=", value, "cosType");
            return (Criteria) this;
        }

        public Criteria andCosTypeIn(List<Integer> values) {
            addCriterion("cos_type in", values, "cosType");
            return (Criteria) this;
        }

        public Criteria andCosTypeNotIn(List<Integer> values) {
            addCriterion("cos_type not in", values, "cosType");
            return (Criteria) this;
        }

        public Criteria andCosTypeBetween(Integer value1, Integer value2) {
            addCriterion("cos_type between", value1, value2, "cosType");
            return (Criteria) this;
        }

        public Criteria andCosTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("cos_type not between", value1, value2, "cosType");
            return (Criteria) this;
        }

        public Criteria andTransMethodIsNull() {
            addCriterion("trans_method is null");
            return (Criteria) this;
        }

        public Criteria andTransMethodIsNotNull() {
            addCriterion("trans_method is not null");
            return (Criteria) this;
        }

        public Criteria andTransMethodEqualTo(String value) {
            addCriterion("trans_method =", value, "transMethod");
            return (Criteria) this;
        }

        public Criteria andTransMethodNotEqualTo(String value) {
            addCriterion("trans_method <>", value, "transMethod");
            return (Criteria) this;
        }

        public Criteria andTransMethodGreaterThan(String value) {
            addCriterion("trans_method >", value, "transMethod");
            return (Criteria) this;
        }

        public Criteria andTransMethodGreaterThanOrEqualTo(String value) {
            addCriterion("trans_method >=", value, "transMethod");
            return (Criteria) this;
        }

        public Criteria andTransMethodLessThan(String value) {
            addCriterion("trans_method <", value, "transMethod");
            return (Criteria) this;
        }

        public Criteria andTransMethodLessThanOrEqualTo(String value) {
            addCriterion("trans_method <=", value, "transMethod");
            return (Criteria) this;
        }

        public Criteria andTransMethodLike(String value) {
            addCriterion("trans_method like", value, "transMethod");
            return (Criteria) this;
        }

        public Criteria andTransMethodNotLike(String value) {
            addCriterion("trans_method not like", value, "transMethod");
            return (Criteria) this;
        }

        public Criteria andTransMethodIn(List<String> values) {
            addCriterion("trans_method in", values, "transMethod");
            return (Criteria) this;
        }

        public Criteria andTransMethodNotIn(List<String> values) {
            addCriterion("trans_method not in", values, "transMethod");
            return (Criteria) this;
        }

        public Criteria andTransMethodBetween(String value1, String value2) {
            addCriterion("trans_method between", value1, value2, "transMethod");
            return (Criteria) this;
        }

        public Criteria andTransMethodNotBetween(String value1, String value2) {
            addCriterion("trans_method not between", value1, value2, "transMethod");
            return (Criteria) this;
        }

        public Criteria andQttComplDateIsNull() {
            addCriterion("qtt_compl_date is null");
            return (Criteria) this;
        }

        public Criteria andQttComplDateIsNotNull() {
            addCriterion("qtt_compl_date is not null");
            return (Criteria) this;
        }

        public Criteria andQttComplDateEqualTo(Date value) {
            addCriterion("qtt_compl_date =", value, "qttComplDate");
            return (Criteria) this;
        }

        public Criteria andQttComplDateNotEqualTo(Date value) {
            addCriterion("qtt_compl_date <>", value, "qttComplDate");
            return (Criteria) this;
        }

        public Criteria andQttComplDateGreaterThan(Date value) {
            addCriterion("qtt_compl_date >", value, "qttComplDate");
            return (Criteria) this;
        }

        public Criteria andQttComplDateGreaterThanOrEqualTo(Date value) {
            addCriterion("qtt_compl_date >=", value, "qttComplDate");
            return (Criteria) this;
        }

        public Criteria andQttComplDateLessThan(Date value) {
            addCriterion("qtt_compl_date <", value, "qttComplDate");
            return (Criteria) this;
        }

        public Criteria andQttComplDateLessThanOrEqualTo(Date value) {
            addCriterion("qtt_compl_date <=", value, "qttComplDate");
            return (Criteria) this;
        }

        public Criteria andQttComplDateIn(List<Date> values) {
            addCriterion("qtt_compl_date in", values, "qttComplDate");
            return (Criteria) this;
        }

        public Criteria andQttComplDateNotIn(List<Date> values) {
            addCriterion("qtt_compl_date not in", values, "qttComplDate");
            return (Criteria) this;
        }

        public Criteria andQttComplDateBetween(Date value1, Date value2) {
            addCriterion("qtt_compl_date between", value1, value2, "qttComplDate");
            return (Criteria) this;
        }

        public Criteria andQttComplDateNotBetween(Date value1, Date value2) {
            addCriterion("qtt_compl_date not between", value1, value2, "qttComplDate");
            return (Criteria) this;
        }

        public Criteria andCreateAccountIsNull() {
            addCriterion("create_account is null");
            return (Criteria) this;
        }

        public Criteria andCreateAccountIsNotNull() {
            addCriterion("create_account is not null");
            return (Criteria) this;
        }

        public Criteria andCreateAccountEqualTo(String value) {
            addCriterion("create_account =", value, "createAccount");
            return (Criteria) this;
        }

        public Criteria andCreateAccountNotEqualTo(String value) {
            addCriterion("create_account <>", value, "createAccount");
            return (Criteria) this;
        }

        public Criteria andCreateAccountGreaterThan(String value) {
            addCriterion("create_account >", value, "createAccount");
            return (Criteria) this;
        }

        public Criteria andCreateAccountGreaterThanOrEqualTo(String value) {
            addCriterion("create_account >=", value, "createAccount");
            return (Criteria) this;
        }

        public Criteria andCreateAccountLessThan(String value) {
            addCriterion("create_account <", value, "createAccount");
            return (Criteria) this;
        }

        public Criteria andCreateAccountLessThanOrEqualTo(String value) {
            addCriterion("create_account <=", value, "createAccount");
            return (Criteria) this;
        }

        public Criteria andCreateAccountLike(String value) {
            addCriterion("create_account like", value, "createAccount");
            return (Criteria) this;
        }

        public Criteria andCreateAccountNotLike(String value) {
            addCriterion("create_account not like", value, "createAccount");
            return (Criteria) this;
        }

        public Criteria andCreateAccountIn(List<String> values) {
            addCriterion("create_account in", values, "createAccount");
            return (Criteria) this;
        }

        public Criteria andCreateAccountNotIn(List<String> values) {
            addCriterion("create_account not in", values, "createAccount");
            return (Criteria) this;
        }

        public Criteria andCreateAccountBetween(String value1, String value2) {
            addCriterion("create_account between", value1, value2, "createAccount");
            return (Criteria) this;
        }

        public Criteria andCreateAccountNotBetween(String value1, String value2) {
            addCriterion("create_account not between", value1, value2, "createAccount");
            return (Criteria) this;
        }

        public Criteria andQttBatchRemkIsNull() {
            addCriterion("qtt_batch_remk is null");
            return (Criteria) this;
        }

        public Criteria andQttBatchRemkIsNotNull() {
            addCriterion("qtt_batch_remk is not null");
            return (Criteria) this;
        }

        public Criteria andQttBatchRemkEqualTo(String value) {
            addCriterion("qtt_batch_remk =", value, "qttBatchRemk");
            return (Criteria) this;
        }

        public Criteria andQttBatchRemkNotEqualTo(String value) {
            addCriterion("qtt_batch_remk <>", value, "qttBatchRemk");
            return (Criteria) this;
        }

        public Criteria andQttBatchRemkGreaterThan(String value) {
            addCriterion("qtt_batch_remk >", value, "qttBatchRemk");
            return (Criteria) this;
        }

        public Criteria andQttBatchRemkGreaterThanOrEqualTo(String value) {
            addCriterion("qtt_batch_remk >=", value, "qttBatchRemk");
            return (Criteria) this;
        }

        public Criteria andQttBatchRemkLessThan(String value) {
            addCriterion("qtt_batch_remk <", value, "qttBatchRemk");
            return (Criteria) this;
        }

        public Criteria andQttBatchRemkLessThanOrEqualTo(String value) {
            addCriterion("qtt_batch_remk <=", value, "qttBatchRemk");
            return (Criteria) this;
        }

        public Criteria andQttBatchRemkLike(String value) {
            addCriterion("qtt_batch_remk like", value, "qttBatchRemk");
            return (Criteria) this;
        }

        public Criteria andQttBatchRemkNotLike(String value) {
            addCriterion("qtt_batch_remk not like", value, "qttBatchRemk");
            return (Criteria) this;
        }

        public Criteria andQttBatchRemkIn(List<String> values) {
            addCriterion("qtt_batch_remk in", values, "qttBatchRemk");
            return (Criteria) this;
        }

        public Criteria andQttBatchRemkNotIn(List<String> values) {
            addCriterion("qtt_batch_remk not in", values, "qttBatchRemk");
            return (Criteria) this;
        }

        public Criteria andQttBatchRemkBetween(String value1, String value2) {
            addCriterion("qtt_batch_remk between", value1, value2, "qttBatchRemk");
            return (Criteria) this;
        }

        public Criteria andQttBatchRemkNotBetween(String value1, String value2) {
            addCriterion("qtt_batch_remk not between", value1, value2, "qttBatchRemk");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}